<!-- This comment will put IE 6, 7 and 8 in quirks mode -->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<title>eCommerce: Plik źródłowy D:/CentrumXP/e-Commerce/eCommerceDev/SklepDAO/DocumentDAO.cs</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javaScript" src="search/search.js"></script>
<link href="doxygen.css" rel="stylesheet" type="text/css"/>
</head>
<body onload='searchBox.OnSelectItem(0);'>
<!-- Wygenerowano przez Doxygen 1.6.1 -->
<script type="text/javascript"><!--
var searchBox = new SearchBox("searchBox", "search",false,'Szukaj');
--></script>
<div class="navigation" id="top">
  <div class="tabs">
    <ul>
      <li><a href="index.html"><span>Strona&nbsp;główna</span></a></li>
      <li><a href="namespaces.html"><span>Pakiety</span></a></li>
      <li><a href="annotated.html"><span>Klasy</span></a></li>
      <li class="current"><a href="files.html"><span>Pliki</span></a></li>
      <li>
        <div id="MSearchBox" class="MSearchBoxInactive">
        <img id="MSearchSelect" src="search/search.png"
             onmouseover="return searchBox.OnSearchSelectShow()"
             onmouseout="return searchBox.OnSearchSelectHide()"
             alt=""/>
        <input type="text" id="MSearchField" value="Szukaj" accesskey="S"
             onfocus="searchBox.OnSearchFieldFocus(true)" 
             onblur="searchBox.OnSearchFieldFocus(false)" 
             onkeyup="searchBox.OnSearchFieldChange(event)"/>
        <a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="search/close.png" alt=""/></a>
        </div>
      </li>
    </ul>
  </div>
  <div class="tabs">
    <ul>
      <li><a href="files.html"><span>Lista&nbsp;plików</span></a></li>
      <li><a href="globals.html"><span>Składowe&nbsp;plików</span></a></li>
    </ul>
  </div>
<h1>D:/CentrumXP/e-Commerce/eCommerceDev/SklepDAO/DocumentDAO.cs</h1><a href="_document_d_a_o_8cs.html">Idź do dokumentacji tego pliku.</a><div class="fragment"><pre class="fragment"><a name="l00001"></a><a class="code" href="_document_d_a_o_8cs.html#a81a223a02c34d82b47199f08308847f2">00001</a> ﻿using <a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>;
<a name="l00002"></a>00002 <span class="keyword">using</span> <a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>.Collections.Generic;
<a name="l00003"></a>00003 <span class="keyword">using</span> <a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>.Data.SqlClient;
<a name="l00004"></a>00004 <span class="keyword">using</span> <a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>.Data;
<a name="l00005"></a>00005 <span class="keyword">using</span> <a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>.Text;
<a name="l00006"></a>00006 
<a name="l00007"></a>00007 <span class="keyword">using</span> ShopModel;
<a name="l00008"></a>00008 
<a name="l00009"></a>00009 <span class="keyword">namespace </span>ShopDAO
<a name="l00010"></a>00010 {
<a name="l00011"></a><a class="code" href="class_shop_d_a_o_1_1_document_d_a_o.html">00011</a>     <span class="keyword">public</span> <span class="keyword">class </span><a class="code" href="class_shop_d_a_o_1_1_document_d_a_o.html">DocumentDAO</a>
<a name="l00012"></a>00012     {
<a name="l00013"></a>00013         <span class="keyword">private</span> <span class="keywordtype">string</span> connectionString;
<a name="l00014"></a>00014 
<a name="l00015"></a><a class="code" href="class_shop_d_a_o_1_1_document_d_a_o.html#a5459e44dd5347076f4ed6b5e87bfc5a6">00015</a>         <span class="keyword">public</span> <a class="code" href="class_shop_d_a_o_1_1_document_d_a_o.html#a5459e44dd5347076f4ed6b5e87bfc5a6">DocumentDAO</a>()
<a name="l00016"></a>00016         {
<a name="l00017"></a>00017             connectionString = <a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>.Configuration.ConfigurationManager.ConnectionStrings[<span class="stringliteral">&quot;csShop&quot;</span>].ConnectionString;
<a name="l00018"></a>00018         }
<a name="l00019"></a>00019 
<a name="l00025"></a><a class="code" href="class_shop_d_a_o_1_1_document_d_a_o.html#a34ca2c1b69b7420a998531b049997218">00025</a>         <span class="keyword">public</span>  <span class="keywordtype">bool</span> <a class="code" href="class_shop_d_a_o_1_1_document_d_a_o.html#a34ca2c1b69b7420a998531b049997218" title="Zapisuje do bazy informacje o dokumencie dodanym do jednego z produktów (Saves information...">SaveDocument</a>(<a class="code" href="class_shop_model_1_1_document_info.html" title="Klasa przechowująca informacje o dokumencie dodawanym do produktu (Class storing...">DocumentInfo</a> Document)
<a name="l00026"></a>00026         {
<a name="l00027"></a>00027             SqlConnection connection = <span class="keyword">new</span> SqlConnection(connectionString);
<a name="l00028"></a>00028             SqlCommand sqlCommand = connection.CreateCommand();
<a name="l00029"></a>00029 
<a name="l00030"></a>00030             sqlCommand.CommandText = <span class="stringliteral">&quot;SaveDocument&quot;</span>;
<a name="l00031"></a>00031             sqlCommand.CommandType = <a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>.Data.CommandType.StoredProcedure;
<a name="l00032"></a>00032 
<a name="l00033"></a>00033             sqlCommand.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@FileName&quot;</span>, Document.<a class="code" href="class_shop_model_1_1_document_info.html#a36c2c145f9e861218563bf963269500a">FileName</a>));
<a name="l00034"></a>00034             sqlCommand.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@ProductID&quot;</span>, Document.<a class="code" href="class_shop_model_1_1_document_info.html#a6b24efd21f9bab486f144b37cdb9ed6b">ProductID</a>));
<a name="l00035"></a>00035 
<a name="l00036"></a>00036             <span class="keywordflow">try</span>
<a name="l00037"></a>00037             {
<a name="l00038"></a>00038                 connection.Open();
<a name="l00039"></a>00039                 <span class="keywordflow">return</span> sqlCommand.ExecuteNonQuery() &gt; 0;
<a name="l00040"></a>00040             }
<a name="l00041"></a>00041             <span class="keywordflow">catch</span> (Exception ex)
<a name="l00042"></a>00042             {
<a name="l00043"></a>00043                 ErrorLogger.LogError(ex);
<a name="l00044"></a>00044                 <span class="keywordflow">return</span> <span class="keyword">false</span>;
<a name="l00045"></a>00045             }
<a name="l00046"></a>00046             <span class="keywordflow">finally</span>
<a name="l00047"></a>00047             {
<a name="l00048"></a>00048                 connection.Close();
<a name="l00049"></a>00049             }
<a name="l00050"></a>00050         }
<a name="l00051"></a>00051 
<a name="l00057"></a><a class="code" href="class_shop_d_a_o_1_1_document_d_a_o.html#a451bd2ca340618a60b7cdd04dd7eede6">00057</a>         <span class="keyword">public</span>  List&lt;DocumentInfo&gt; <a class="code" href="class_shop_d_a_o_1_1_document_d_a_o.html#a451bd2ca340618a60b7cdd04dd7eede6" title="Pobiera listę obiktów typu DocumentInfo dolączonych do produktu o podanym id (Downloads...">GetDocuments</a>(<span class="keywordtype">int</span> ProductID)
<a name="l00058"></a>00058         {
<a name="l00059"></a>00059             SqlConnection sqlC = <span class="keyword">new</span> SqlConnection(connectionString);
<a name="l00060"></a>00060             SqlCommand command = sqlC.CreateCommand();
<a name="l00061"></a>00061             SqlDataReader sqlR;
<a name="l00062"></a>00062 
<a name="l00063"></a>00063             List&lt;DocumentInfo&gt; result = <span class="keyword">new</span> List&lt;DocumentInfo&gt;();
<a name="l00064"></a>00064 
<a name="l00065"></a>00065             command.CommandText = <span class="stringliteral">&quot;GetDocuments&quot;</span>;
<a name="l00066"></a>00066             command.CommandType = CommandType.StoredProcedure;
<a name="l00067"></a>00067 
<a name="l00068"></a>00068             command.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@ProductID&quot;</span>, ProductID));
<a name="l00069"></a>00069 
<a name="l00070"></a>00070             <span class="keywordflow">try</span>
<a name="l00071"></a>00071             {
<a name="l00072"></a>00072                 sqlC.Open();
<a name="l00073"></a>00073                 sqlR = command.ExecuteReader();
<a name="l00074"></a>00074 
<a name="l00075"></a>00075                 <span class="keywordflow">while</span> (sqlR.Read())
<a name="l00076"></a>00076                 {
<a name="l00077"></a>00077                     result.Add(<span class="keyword">new</span> <a class="code" href="class_shop_model_1_1_document_info.html" title="Klasa przechowująca informacje o dokumencie dodawanym do produktu (Class storing...">DocumentInfo</a>((<span class="keywordtype">int</span>)sqlR[<span class="stringliteral">&quot;IDdocument&quot;</span>], (<span class="keywordtype">int</span>)sqlR[<span class="stringliteral">&quot;ProductID&quot;</span>], (<span class="keywordtype">string</span>)sqlR[<span class="stringliteral">&quot;FileName&quot;</span>]));
<a name="l00078"></a>00078                 }
<a name="l00079"></a>00079                 sqlR.Close();
<a name="l00080"></a>00080             }
<a name="l00081"></a>00081             <span class="keywordflow">catch</span> (Exception ex)
<a name="l00082"></a>00082             {
<a name="l00083"></a>00083                 ErrorLogger.LogError(ex);
<a name="l00084"></a>00084                 <span class="keywordflow">return</span> null;
<a name="l00085"></a>00085             }
<a name="l00086"></a>00086             <span class="keywordflow">finally</span>
<a name="l00087"></a>00087             {
<a name="l00088"></a>00088                 sqlC.Close();
<a name="l00089"></a>00089             }
<a name="l00090"></a>00090 
<a name="l00091"></a>00091             <span class="keywordflow">return</span> result;
<a name="l00092"></a>00092         }
<a name="l00093"></a>00093 
<a name="l00099"></a><a class="code" href="class_shop_d_a_o_1_1_document_d_a_o.html#a4c1b66ebd260dc23bd13d5faa1023dae">00099</a>         <span class="keyword">public</span>  <span class="keywordtype">bool</span> <a class="code" href="class_shop_d_a_o_1_1_document_d_a_o.html#a4c1b66ebd260dc23bd13d5faa1023dae" title="Usuwa z bazy dancyh pliki dokumentów dla produktu o podanym id (Deletes document’s...">DeleteDocument</a>(<span class="keywordtype">int</span> DocumentID)
<a name="l00100"></a>00100         {
<a name="l00101"></a>00101             SqlConnection connection = <span class="keyword">new</span> SqlConnection(connectionString);
<a name="l00102"></a>00102             SqlCommand sqlCommand = connection.CreateCommand();
<a name="l00103"></a>00103 
<a name="l00104"></a>00104             sqlCommand.CommandText = <span class="stringliteral">&quot;DeleteDocument&quot;</span>;
<a name="l00105"></a>00105             sqlCommand.CommandType = <a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>.Data.CommandType.StoredProcedure;
<a name="l00106"></a>00106 
<a name="l00107"></a>00107             sqlCommand.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@DocumentID&quot;</span>, DocumentID));
<a name="l00108"></a>00108 
<a name="l00109"></a>00109             <span class="keywordflow">try</span>
<a name="l00110"></a>00110             {
<a name="l00111"></a>00111                 connection.Open();
<a name="l00112"></a>00112                 <span class="keywordflow">return</span> (<span class="keywordtype">int</span>)sqlCommand.ExecuteScalar() &gt; 0;
<a name="l00113"></a>00113             }
<a name="l00114"></a>00114             <span class="keywordflow">catch</span> (Exception ex)
<a name="l00115"></a>00115             {
<a name="l00116"></a>00116                 ErrorLogger.LogError(ex);
<a name="l00117"></a>00117                 <span class="keywordflow">return</span> <span class="keyword">false</span>;
<a name="l00118"></a>00118             }
<a name="l00119"></a>00119             <span class="keywordflow">finally</span>
<a name="l00120"></a>00120             {
<a name="l00121"></a>00121                 connection.Close();
<a name="l00122"></a>00122             }
<a name="l00123"></a>00123         }
<a name="l00124"></a>00124 
<a name="l00125"></a>00125 
<a name="l00131"></a><a class="code" href="class_shop_d_a_o_1_1_document_d_a_o.html#a9b5f7c3c5363b75d8f188f9430a5d302">00131</a>         <span class="keyword">public</span> <a class="code" href="class_shop_model_1_1_document_info.html" title="Klasa przechowująca informacje o dokumencie dodawanym do produktu (Class storing...">DocumentInfo</a> <a class="code" href="class_shop_d_a_o_1_1_document_d_a_o.html#a9b5f7c3c5363b75d8f188f9430a5d302" title="Pobiera obikt typu DocumentInfo dolączony do produktu o podanym id (Downloads DocumentInfo...">GetDocument</a>(<span class="keywordtype">int</span> DocumentID)
<a name="l00132"></a>00132         {
<a name="l00133"></a>00133             SqlConnection sqlC = <span class="keyword">new</span> SqlConnection(connectionString);
<a name="l00134"></a>00134             SqlCommand command = sqlC.CreateCommand();
<a name="l00135"></a>00135             SqlDataReader sqlR;
<a name="l00136"></a>00136 
<a name="l00137"></a>00137             <a class="code" href="class_shop_model_1_1_document_info.html" title="Klasa przechowująca informacje o dokumencie dodawanym do produktu (Class storing...">DocumentInfo</a> result = null;
<a name="l00138"></a>00138 
<a name="l00139"></a>00139             command.CommandText = <span class="stringliteral">&quot;GetDocuments&quot;</span>;
<a name="l00140"></a>00140             command.CommandType = CommandType.StoredProcedure;
<a name="l00141"></a>00141 
<a name="l00142"></a>00142             command.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@DocumentID&quot;</span>, DocumentID));
<a name="l00143"></a>00143 
<a name="l00144"></a>00144             <span class="keywordflow">try</span>
<a name="l00145"></a>00145             {
<a name="l00146"></a>00146                 sqlC.Open();
<a name="l00147"></a>00147                 sqlR = command.ExecuteReader();
<a name="l00148"></a>00148 
<a name="l00149"></a>00149                 <span class="keywordflow">if</span> (sqlR.Read())
<a name="l00150"></a>00150                     result = <span class="keyword">new</span> <a class="code" href="class_shop_model_1_1_document_info.html" title="Klasa przechowująca informacje o dokumencie dodawanym do produktu (Class storing...">DocumentInfo</a>((<span class="keywordtype">int</span>)sqlR[<span class="stringliteral">&quot;IDdocument&quot;</span>], (int)sqlR[<span class="stringliteral">&quot;ProductID&quot;</span>], (<span class="keywordtype">string</span>)sqlR[<span class="stringliteral">&quot;FileName&quot;</span>]);
<a name="l00151"></a>00151                 
<a name="l00152"></a>00152                 sqlR.Close();
<a name="l00153"></a>00153             }
<a name="l00154"></a>00154             <span class="keywordflow">catch</span> (Exception ex)
<a name="l00155"></a>00155             {
<a name="l00156"></a>00156                 ErrorLogger.LogError(ex);
<a name="l00157"></a>00157                 <span class="keywordflow">return</span> null;
<a name="l00158"></a>00158             }
<a name="l00159"></a>00159             <span class="keywordflow">finally</span>
<a name="l00160"></a>00160             {
<a name="l00161"></a>00161                 sqlC.Close();
<a name="l00162"></a>00162             }
<a name="l00163"></a>00163 
<a name="l00164"></a>00164             <span class="keywordflow">return</span> result;
<a name="l00165"></a>00165         }
<a name="l00166"></a>00166 
<a name="l00172"></a><a class="code" href="class_shop_d_a_o_1_1_document_d_a_o.html#abec64c99119ddcbd47686515a903e769">00172</a>         <span class="keyword">public</span> <span class="keywordtype">bool</span> <a class="code" href="class_shop_d_a_o_1_1_document_d_a_o.html#abec64c99119ddcbd47686515a903e769" title="Removes document’s files from the database.">DeleteDocumentsFromDataBase</a>(<span class="keywordtype">int</span> productID)
<a name="l00173"></a>00173         {
<a name="l00174"></a>00174             SqlConnection connection = <span class="keyword">new</span> SqlConnection(connectionString);
<a name="l00175"></a>00175             SqlCommand sqlCommand = connection.CreateCommand();
<a name="l00176"></a>00176 
<a name="l00177"></a>00177 
<a name="l00178"></a>00178 
<a name="l00179"></a>00179             sqlCommand.CommandText = <span class="stringliteral">&quot;DeleteDocumentsFromDataBase&quot;</span>;
<a name="l00180"></a>00180             sqlCommand.CommandType = <a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>.Data.CommandType.StoredProcedure;
<a name="l00181"></a>00181             sqlCommand.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@productID&quot;</span>, productID));
<a name="l00182"></a>00182 
<a name="l00183"></a>00183 
<a name="l00184"></a>00184 
<a name="l00185"></a>00185             <span class="keywordflow">try</span>
<a name="l00186"></a>00186             {
<a name="l00187"></a>00187                 connection.Open();
<a name="l00188"></a>00188                 sqlCommand.ExecuteNonQuery();
<a name="l00189"></a>00189                 <span class="keywordflow">return</span> <span class="keyword">true</span>;
<a name="l00190"></a>00190             }
<a name="l00191"></a>00191             <span class="keywordflow">catch</span> (Exception ex)
<a name="l00192"></a>00192             {
<a name="l00193"></a>00193                 ErrorLogger.LogError(ex);
<a name="l00194"></a>00194                 <span class="keywordflow">return</span> <span class="keyword">false</span>;
<a name="l00195"></a>00195             }
<a name="l00196"></a>00196             <span class="keywordflow">finally</span>
<a name="l00197"></a>00197             {
<a name="l00198"></a>00198                 connection.Close();
<a name="l00199"></a>00199             }
<a name="l00200"></a>00200 
<a name="l00201"></a>00201         }
<a name="l00202"></a>00202     }
<a name="l00203"></a>00203 }
</pre></div></div>
<!--- window showing the filter options -->
<div id="MSearchSelectWindow"
     onmouseover="return searchBox.OnSearchSelectShow()"
     onmouseout="return searchBox.OnSearchSelectHide()"
     onkeydown="return searchBox.OnSearchSelectKey(event)">
<a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(0)"><span class="SelectionMark">&nbsp;</span>All</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(1)"><span class="SelectionMark">&nbsp;</span>Klasy</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(2)"><span class="SelectionMark">&nbsp;</span>Przestrzenie nazw</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(3)"><span class="SelectionMark">&nbsp;</span>Pliki</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(4)"><span class="SelectionMark">&nbsp;</span>Funkcje</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(5)"><span class="SelectionMark">&nbsp;</span>Zmienne</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(6)"><span class="SelectionMark">&nbsp;</span>Wyliczenia</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(7)"><span class="SelectionMark">&nbsp;</span>Właściwości</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(8)"><span class="SelectionMark">&nbsp;</span>Zdarzenia</a></div>

<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="" frameborder="0" 
        name="MSearchResults" id="MSearchResults">
</iframe>
</div>

<hr size="1"/><address style="text-align: right;"><small>Wygenerowano Mon Nov 9 06:08:17 2009 dla eCommerce programem&nbsp;
<a href="http://www.doxygen.org/index.html">
<img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.6.1 </small></address>
</body>
</html>
